<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>数据表优化</title>
<link rel="stylesheet" type="text/css" href="__PUBLIC__/layui/css/layui.css" media="all">
<link rel="stylesheet" type="text/css" href="__PUBLIC__/Admin/css/table.css" media="all">

</head>

<body>
<div class="header">
<include file="Baksql/nav" />
<span class="tabscount"><span class="padding"><a href="javascript:;"  class="all_optimize">一键优化</a>&nbsp;&nbsp;<a href="javascript:;" class="all_repair">一键修复</a></span>&nbsp;&nbsp;总共<span class="counts">{$tables}</span>个表,共{$total}</span>
<div class="layui-form">
  <table class="layui-table" id="tb">
    <colgroup>
      <col width="50">
      <col width="150">
      <col width="150">
      <col width="200">
      <col>
    </colgroup>
    <thead>
      <tr>
        <th class="algin">数据表</th>
        <th class="algin">数据量</th>
        <th class="algin">数据大小</th>
        <th class="algin">排序规则</th>
        <th class="algin">引擎</th>
        <th class="algin">创建时间</th>
        <th class="algin">最近操作</th>
        <th class="algin">状态</th>
        <th class="algin">操作</th>
      </tr> 
    </thead>
    <tbody>
      <volist name="list" id="table">
      <tr class="algin">
          <td>{$table.name}</td>
          <td>{$table.rows}</td>
          <td>{$table.data_length|format_bytes}</td>
          <td>{$table.collation}</td>
          <td>{$table.engine}</td>
          <td>{$table.create_time}</td>
          <td>{$table.update_time}</td>
          <td class="info">-</td>
          <td class="action">
          <div class="layui-btn-group">
          <button class="layui-btn layui-btn-primary layui-btn-small optimize" title="优化表信息" data-name="{$table.name}" data-row="{$i}">优化表</button>
          <button class="layui-btn layui-btn-primary layui-btn-small repair" title="修复表信息" data-name="{$table.name}" data-row="{$i}">修复表</button>
          </div>
          </td>
      </tr>
  </volist>
    </tbody>
  </table>
</div>

</div>
<script src="__PUBLIC__/js/jquery-1.8.3.min.js" ></script>
<script src="__PUBLIC__/layui/layui.js" ></script>
<script src="__PUBLIC__/admin/js/table.js" ></script>
</body>
</html>
